Re: drop if exists - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: drop if exists
Date
Msg-id AB7A45D0851DC49E56AE3946@[192.168.100.105]
Whole thread Raw
In response to Re: drop if exists  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
--On Samstag, Oktober 15, 2005 17:20:06 +0200 Martijn van Oosterhout 
<kleptog@svana.org> wrote:

> Although the
> effect is obvious for functions, it seems to me that it would be cool
> to make a CREATE OR REPLACE TABLE that simply does nothing if the table
> already exists with the right format.

Hmm i don't think this is the right semantic, because CREATE OR REPLACE for 
other objects does indeed something, simply ignoring an existing object 
isn't what i would expect.

--  Thanks
                   Bernd


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: drop if exists
Next
From: Anuj Tripathi
Date:
Subject: Plan structure